package com.ruoyi.tb.lmt.mapper;

import com.ruoyi.tb.lmt.domain.OilSampleDetection;
import com.ruoyi.tb.lmt.domain.vo.OilSampleDetectionVo;
import com.ruoyi.common.core.mapper.BaseMapperPlus;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.time.LocalDate;
import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * 油压减震器Mapper接口
 *
 * @author ruoyi
 * @date 2023-12-20
 */
@Mapper
public interface OilSampleDetectionMapper extends BaseMapperPlus<OilSampleDetectionMapper, OilSampleDetection, OilSampleDetectionVo> {

    List<OilSampleDetectionVo> selectOil(@Param("lmtNumber") String lmtNumber, @Param("oilType") String oilType);

    int queryExistsByLmtIdAndTestDate(@Param("oilDate") String oilDate, @Param("oilId") String oilId, @Param("oilType") String oilType);

    List<OilSampleDetectionVo> selectOilByLmtNumber(@Param("lmtNumber") String lmtNumber, @Param("startDate") Date startDate, @Param("endDate") Date endDate);

    List<OilSampleDetectionVo> selectOilByMap(Map<String, Object> params);

    List<OilSampleDetection> selectListByDate(LocalDate date);

    List<OilSampleDetectionVo> selectOilNew(String lmtNumber, String oilType);

    OilSampleDetectionVo selectOilDate(@Param("lmtNumber") String lmtNumber, @Param("oilType") String oilType, @Param("oilData") String oilData);
}
